<?php include_once("DataProvider.php")?>
<!doctype html>
<!doctype html> 
<html class="no-js">

	<?php
	include_once("header.php");
	?>
		<!-- ENDS HEADER --><!-- TemplateBeginEditable name="EditRegion1" -->
		<!-- MAIN -->
        <div id="main">
          <div class="wrapper cf">
            <!-- portfolio content-->
            <div id="portfolio-content" class="cf">
              <ul id="filter-buttons">
                <li><a href="#" data-filter=".ngoaithat">NGOẠI THẤT</a></li>
              </ul>
              <!-- Filter container -->
              <div id="filter-container" class="cf">
                <?php
                   			$sql="select * from sanpham sp, loaisanpham lsp where sp.id_danhmuc=lsp.id_loaisanpham and id_loaisanpham=2";
							$result=DataProvider::ExecuteQuery($sql);
							while($row=mysql_fetch_array($result))
							{
								if($row["data-filter"]!=NULL)
								{
								
								
					?>
                <figure class="<?php echo $row["data-filter"]?>"> <a href="project.html" class="thumb"><img src="img/dummies/featured/<?php echo $row["hinhsanpham"];?>" alt="alt" /></a>
                  <figcaption> <a href="project.html">
                    <h3 class="heading"><?php echo $row["tensanpham"];?></h3>
                    </a><?php echo $row["motasanpham"];?> <br>
                    Tình trạng:
                    <?php if($row["tinhtrang"]==1){echo "Còn hàng";}else {echo "Hết hàng";}?>
                  </figcaption>
                </figure>
                <?php }}?>
              </div>
              <!-- ENDS Filter container -->
            </div>
            <!-- ENDS featured -->
          </div>
          <!-- ENDS WRAPPER -->
        </div>
        <!-- ENDS MAIN -->
		<!-- TemplateEndEditable -->
		<!-- BEGINS FOOTER -->
<?php
include_once("footer.php");
?>
<!-- ENDS FOOTER -->
		
	</body>
	
	
	
</html>